﻿CREATE PROCEDURE [branding].[GetBlobByGuid]
	@blobGuid uniqueidentifier
AS
	select	bb.ID,
			CAST('blob' as varchar(10)) as ObjectType,
			bb.Tag,
			bb.SubTag,
			bb.ResourceId,
			bb.Brand,
			bb.ContentLength,
			bb.MimeType,
			bb.Blob,
			bb.BlobGuid
	from	branding.Blob as bb
	where	bb.BlobGuid = @blobGuid;
RETURN 0